Model Table COUNTERPART STRUCTURE 1

Attributes

Attribute Description (where applicable)
CounterpartCounterpart code, connects to the Fact tables
DescriptionThe description, displayed text in the counterpart structure
Structure IdThe Id for the structure seleted (by configuration) to be shown in this counterpart structure
tmpItem above description, values on all rows including top level

Hierarchies

Hierarchy Level
Counterpart Structure 1
CPSL01
CPSL02
CPSL03
CPSL04
CPSL05
CPSL06
CPSL07
CPSL08
CPSL09
CPSL10

USED BY MODEL(S)

Model Name
Cash Planning
General Ledger

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
COUNTERPART STRUCTURE 1DIM_GL_COUNT_STRUCT_1_TMDIM_GL_COUNT_STRUCT_1_BIDIM_GL_COUNT_STRUCT_1On Line